package com.isoft.filelistener.dao;

import com.isoft.filelistener.entity.BaseCfueSon;
import com.isoft.filelistener.entity.MetaData;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface BaseCfueDao {
    @Insert("insert into TEAM_03.BASE_CFUE(SENDER,RECEIVER,SEQUENCE,SEND_TIME,TYPE,STYP," +
            "FLIGHT_CODE,FLIGHT_CFTP,FLIGHT_AWCD,FLIGHT_STNM,FLIGHT_RSTN,FLIGHT_CFSA,FLIGHT_TTWC,FLIGHT_MXLW,FLIGHT_RLLW) values(" +
            "#{metaData.sender},#{metaData.receiver},#{metaData.sequence},#{metaData.sendTime},#{metaData.type},#{metaData.styp},#{baseCfue.flightCode},#{baseCfue.flightCftp}" +
            ",#{baseCfue.flightAwcd},#{baseCfue.flightStnm},#{baseCfue.rstn},#{baseCfue.cfsa},#{baseCfue.ttwc},#{baseCfue.mxlw},#{baseCfue.rllw})")
    int InsertBaseCfue(@Param("metaData") MetaData metaData, @Param("baseCfue") BaseCfueSon cfue);
}
